package com.ecoolex.chinadutyfree.retailer.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class DirectMailGoodsProductIncrementDataExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public DirectMailGoodsProductIncrementDataExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DirectMailGoodsProductIncrementDataExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public DirectMailGoodsProductIncrementDataExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        DirectMailGoodsProductIncrementDataExample example = new DirectMailGoodsProductIncrementDataExample();
        return example.createCriteria();
    }

    public DirectMailGoodsProductIncrementDataExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public DirectMailGoodsProductIncrementDataExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public DirectMailGoodsProductIncrementDataExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsProductIncrementDataExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public DirectMailGoodsProductIncrementDataExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("directmailgoodsproductincrementdata.Id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.Id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.Id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Id <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.Id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.Id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.Id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.Id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIsNull() {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId is null");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId is not null");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId =", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId <>", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId >", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId >=", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId <", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId <=", value, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.DirectMailProductId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId in", values, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId not in", values, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId between", value1, value2, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andDirectMailProductIdNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.DirectMailProductId not between", value1, value2, "directMailProductId");
            return (Criteria) this;
        }

        public Criteria andCustomNameIsNull() {
            addCriterion("directmailgoodsproductincrementdata.CustomName is null");
            return (Criteria) this;
        }

        public Criteria andCustomNameIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.CustomName is not null");
            return (Criteria) this;
        }

        public Criteria andCustomNameEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName =", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameNotEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName <>", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameGreaterThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName >", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName >=", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameLessThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName <", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName <=", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CustomName <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCustomNameLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName like", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameNotLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.CustomName not like", value, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.CustomName in", values, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameNotIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.CustomName not in", values, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.CustomName between", value1, value2, "customName");
            return (Criteria) this;
        }

        public Criteria andCustomNameNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.CustomName not between", value1, value2, "customName");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNull() {
            addCriterion("directmailgoodsproductincrementdata.SpecNames is null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.SpecNames is not null");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames =", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames <>", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames >", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames >=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames <", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames <=", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.SpecNames <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSpecNamesLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames not like", value, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames not in", values, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andSpecNamesNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.SpecNames not between", value1, value2, "specNames");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andStockNumberIsNull() {
            addCriterion("directmailgoodsproductincrementdata.StockNumber is null");
            return (Criteria) this;
        }

        public Criteria andStockNumberIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.StockNumber is not null");
            return (Criteria) this;
        }

        public Criteria andStockNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber =", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber <>", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber >", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber >=", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber <", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber <=", value, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.StockNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStockNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber in", values, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber not in", values, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber between", value1, value2, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andStockNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.StockNumber not between", value1, value2, "stockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberIsNull() {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber is null");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber is not null");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber =", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber <>", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber >", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber >=", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber <", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber <=", value, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RemainStockNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber in", values, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber not in", values, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber between", value1, value2, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andRemainStockNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.RemainStockNumber not between", value1, value2, "remainStockNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberIsNull() {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber is null");
            return (Criteria) this;
        }

        public Criteria andPaidNumberIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber is not null");
            return (Criteria) this;
        }

        public Criteria andPaidNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber =", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber <>", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber >", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber >=", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber <", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber <=", value, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber in", values, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber not in", values, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber between", value1, value2, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.PaidNumber not between", value1, value2, "paidNumber");
            return (Criteria) this;
        }

        public Criteria andPaidPriceIsNull() {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice is null");
            return (Criteria) this;
        }

        public Criteria andPaidPriceIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice is not null");
            return (Criteria) this;
        }

        public Criteria andPaidPriceEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice =", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice <>", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice >", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice >=", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThan(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice <", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice <=", value, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.PaidPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPaidPriceIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice in", values, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotIn(List<BigDecimal> values) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice not in", values, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice between", value1, value2, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andPaidPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("directmailgoodsproductincrementdata.PaidPrice not between", value1, value2, "paidPrice");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNull() {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber is null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber =", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber <>", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber >", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber >=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber <", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber <=", value, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.OrderNumber <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andOrderNumberIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber not in", values, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andOrderNumberNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.OrderNumber not between", value1, value2, "orderNumber");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("directmailgoodsproductincrementdata.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("directmailgoodsproductincrementdata.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("directmailgoodsproductincrementdata.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("directmailgoodsproductincrementdata.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("directmailgoodsproductincrementdata.RecordTime is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.RecordTime is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.RecordTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.RecordTime not between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("directmailgoodsproductincrementdata.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("directmailgoodsproductincrementdata.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("directmailgoodsproductincrementdata.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("directmailgoodsproductincrementdata.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsproductincrementdata.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("directmailgoodsproductincrementdata.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("directmailgoodsproductincrementdata.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("directmailgoodsproductincrementdata.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(DirectMailGoodsProductIncrementData.Column column) {
            addCriterion(new StringBuilder("directmailgoodsproductincrementdata.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("directmailgoodsproductincrementdata.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private DirectMailGoodsProductIncrementDataExample example;

        protected Criteria(DirectMailGoodsProductIncrementDataExample example) {
            super();
            this.example = example;
        }

        public DirectMailGoodsProductIncrementDataExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(DirectMailGoodsProductIncrementData.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(DirectMailGoodsProductIncrementData.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.chinadutyfree.retailer.entity.DirectMailGoodsProductIncrementDataExample example);
    }
}